# concat(bom_no,itm)=id,
str = "tb_no,prd_no,qty,wh,qty1,tw_no,sc_dd=create_date"
elems = str.split(",")
exchange_str = ""
for elem in elems:
    if ("=" in elem):
        elem_components = elem.split("=")
        exchange_str += elem_components[1] + "=NEW." + elem_components[0] + ","
    else:
        exchange_str += elem + "=NEW." + elem + ","

exchange_str = exchange_str.strip(",")
print(exchange_str)
